EMT Practice Test

1. Question Content...

---

Question1: A business analyst is creating an app for the team. A set of selections must be applied every time an app is opened. Which action should the business analyst take to meet this requirement?

Question2: A business analyst is creating a data model from several Excel files that contain several hundred thousand rows of dat a. The requirements include:
* Users need to drill down to various details within the available data set.
* Several final measures will be repeatedly used. These final measures require combining several fields in a single table.
* User experience and load time is a high priority.
Which action should the business analyst take to meet these requirements?

Question3: A business analyst is creating an app that contains a bar chart showing the top-selling product categories. The users must be able to control the number of product categories shown.
Which action should the business analyst take?

Question4: A business analyst is developing an app that contains a data model with fields: Country, City, Sales, ProductName, and ProductCategory. The global sales manager wants to add new visualizations to this app.
The business analyst must include the following:
* Ability to dynamically change the number of countries and cities
* Display a maximum of 10 countries
* Display a maximum of 5 cities per country
Which steps should the business analyst take?

Question5: A company has recently implemented Qlik Sense. A user is looking to use natural language questions to help create content. Which feature can achieve this goal?

Question6: A business analyst receives multiple requests for a variety of different filter panes to be placed on a dashboard. Users need to filter on many different values across different fields.
Which Qlik Sense feature do the users need to learn about to meet their needs?

Question7: A business analyst receives an image of a dashboard from the HR Director and is asked to recreate the image in Qlik Sense. The image shows charts for:
* Company employee structure
* Average employee salary by region
* Geographical representation of office capacity
* Company retention over time
Which charts will meet these analysis requirements?

Question8: A business analyst has access to all of a company's data for the past 10 years. The source table consists of the following fields: TransactionID, TransactionTime, Transaction Date, Transaction Year, Cardholder, Cardholder address, Cardissuer, and Amount.
Users request to create an app based on this source with the following requirements:
* Users only review the data for the past 2 years
* Data must be updated daily
* Users should not view cardholder info
Which steps should the business analyst complete to improve the app performance?

Question9: A marketing team needs to display sales for a limited number of products by providing a bar chart that the user can control. The visualization has several requirements:
* Starts with the top five products
* Allows the user to change the number of products displayed
* Allows the user to scroll through all products on a mini chart
The business analyst creates a bar chat and a variable. Which steps should the business analyst complete next?

Question10: A customer is developing over 100 apps, each with several sheets that contain multiple visualizations and text objects. The customer wants to standardize all colors used every object across every app. The customer also needs to be able to change these colors quickly, as required.
Which steps should the business analyst take to make sure the color palette is easily maintained in every app?

Question11: An app needs to load a few hundred rows of data from a .csv text file. The file is the result of a concatenated data dump by multiple divisions across several countries. These divisions use different internal systems and processes, which causes country names to appear differently. For example, the United States of America appears in several places as 'USA', 'U.S.A.', or 'US'.
For the country dimension to work properly in the app, the naming of countries must be standardized in the data model.
Which action should the business analyst complete to address this issue?

Question12: A company CFO has requested an app that contains visualizations applicable to analyzing the finance dat a. Each regional finance team will analyze their data and should only have access to the data in their region. The app must contain a high-level sheet that navigates to relevant detail sheets.
Which features support a logical design structure?

Question13: A customer needs to demonstrate the value of sales for each month of the year with a rolling 3-month summary. Which visualization should the business analyst recommend to meet the customer's needs?

Question14: A business analyst is working with retail data for consumer products. The customer is interested in the following:
* Ability to look for outliers on sales volume and margin %
* Ability to understand the clustering of products visually
* Ability to see products that are above the median sales volume
Which action should the business analyst take to implement these requirements?

Question15: The VP of Sales asks a business analyst to include a KPI object on the sales dashboard that shows total sales value for the year 2022, regardless of selections. Existing fields in the data model include Sales and Year.
How should the business analyst write the measure for the KPI object?

Question16: Refer to the exhibit.

A movie analyst is using an app to gain insights into films created in the early 20th century. The analyst reviews the filter for Length Range, notices a hyphen "-", and selects it.
What can the analyst determine from the resulting filter panes?

Question17: A business analyst designs a visualization to analyze a count of products by fixed price ranges. The customer now wants the price ranges to be dynamically modified so they are configurable by the application users. The business analyst modified the dimension axis on the visualization.
Which step should the business analyst complete next?

Question18: A business analyst needs to create a visualization that compares two measures over time using a continuous scale that includes a range. The measures will be Profit and Revenue.
Which visualization should the business analyst use?

Question19: A business analyst using a shared folder mapped to S:\488957004\ receives an Excel file with more than 100 columns. Many of the columns are duplicates. Any current columns that should be used have the suffix '_c' appended to the column name.
Which action should the business analyst take to load the Excel data?

Question20: A business analyst is creating an app for the sales team. The app must meet several requirements:
* Compare 10 top-performing sales representatives and the amount of sales for each
* Investigate margin percentage and total sales by each product category
* View distribution of sales amount
Which visualizations should be used for this app?

Question21: A business analyst needs to build a chart that enables users to analyze the correlation between the following measures for all products:
* Product Sales ($)
* Order Volume
* Margin%
Which visualization should the business analyst use?

Question22: Exhibit.

Refer to the exhibit.
An app is being developed at a university to monitor student exam attempts- Three core tables are loaded into the app for Students, Exams, and Attempts. Students can attempt the same exam multiple times.
Before building any visualizations, the business analyst needs to know:
* How many students are in the system
* What percentage of students have not yet attempted an exam
Which metadata should the analyst focus on to answer these questions?